USE [ctsuAdmin]
GO

/****** Object:  Table [dbo].[Imports]    Script Date: 09/06/2012 19:15:12 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Imports](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Calendar] [nvarchar](50) NULL,
	[SubjectLine] [nvarchar](250) NULL,
	[PatLastName] [nvarchar](50) NULL,
	[PatFirstName] [nvarchar](50) NULL,
	[PatMrn] [nvarchar](50) NULL,
	[PatGender] [nvarchar](50) NULL,
	[Protocol] [nvarchar](50) NULL,
	[SCLastName] [nvarchar](50) NULL,
	[SCFirstName] [nvarchar](50) NULL,
	[SCEmail] [nvarchar](50) NULL,
	[Pi] [nvarchar](50) NULL,
	[PiContact] [nvarchar](50) NULL,
	[RDoc] [nvarchar](50) NULL,
	[RDocContact] [nvarchar](50) NULL,
	[RDocContactBak] [nvarchar](50) NULL,
	[PL] [nvarchar](50) NULL,
	[PLBak] [nvarchar](50) NULL,
	[CCNum] [nvarchar](50) NULL,
	[Location] [nvarchar](50) NULL,
	[Status] [nvarchar](50) NULL,
	[CostCenter] [nvarchar](50) NULL,
	[Nurse] [bit] NULL,
	[Phlebotomy] [bit] NULL,
	[Processing] [bit] NULL,
	[Room] [bit] NULL,
	[EKG_Study] [bit] NULL,
	[EKG_CCI] [bit] NULL,
	[Vitals] [bit] NULL,
	[Ultrasound] [bit] NULL,
	[Dynamap] [bit] NULL,
	[BP] [bit] NULL,
	[Physical] [bit] NULL,
	[XRF] [bit] NULL,
	[Consent] [bit] NULL,
	[Inpatient] [bit] NULL,
	[Outpatient] [bit] NULL,
	[Lab] [bit] NULL,
	[OGIT] [bit] NULL,
	[NP] [bit] NULL,
	[DateStart] [datetime] NULL,
	[DateEnd] [datetime] NULL,
	[VisitLength] [int] NULL,
	[OldRecBody] [nvarchar](500) NULL,
	[AdminDate] [datetime] NULL,
	[DischargeDate] [datetime] NULL,
	[BedDays] [int] NULL,
	[SleepWake] [nvarchar](50) NULL,
	[Handedness] [nvarchar](50) NULL,
	[PWV] [bit] NULL,
	[PAT] [bit] NULL,
	[Carotid] [bit] NULL,
	[Brachial] [bit] NULL,
	[Echo] [bit] NULL,
	[Lower_Extremity] [bit] NULL,
	[RejectReason] [nvarchar](50) NULL,
	[ImportStatus] [int] NULL,
 CONSTRAINT [PK_Imports] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO


